https://store-images.s-microsoft.com/image/apps.34695.86068fcb-e47c-4d57-9666-ab658463a10e.02610634-2cbf-4400-a588-5e2438b95c4e.e8a2d942-c1e0-4eec-ad1d-09dad1da9a3c

Email Any Report

by dataoutput

Generate and email any reports with dynamic date periods using Job Queue.

https://dataoutput.sg/email-any-report

Using Job Queue to generate and email any report with dynamically calculated dates.

  1. Replace the value for 'StartingDate' and/or 'EndingDate' with the keyword Today in the XML.
  2. Today will be the date of the job queue execution.
  3. Combine with the standard functionality of the date formula.

weekly report with recurring job queue running every Friday.
  • StartingDate = Today-5D
  • EndingDate = Today

monthly financial report with recurring job queue running every first day of the month.
  • StartingDate = Today-1M-CM (first day of the previous month)
  • EndingDate = Today-1D (last day of the previous month)

Attach the email scenario 'Email Any Report' to the preferred email account if required.

At a glance

https://store-images.s-microsoft.com/image/apps.35369.86068fcb-e47c-4d57-9666-ab658463a10e.02610634-2cbf-4400-a588-5e2438b95c4e.b52fb1c9-a4a1-44c1-a5d6-4be332de924b
/staticstorage/linux/20241105.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.35369.86068fcb-e47c-4d57-9666-ab658463a10e.02610634-2cbf-4400-a588-5e2438b95c4e.b52fb1c9-a4a1-44c1-a5d6-4be332de924b
https://store-images.s-microsoft.com/image/apps.18133.86068fcb-e47c-4d57-9666-ab658463a10e.02610634-2cbf-4400-a588-5e2438b95c4e.5f6bb044-b1ec-455e-9656-17534a71c050
https://store-images.s-microsoft.com/image/apps.53578.86068fcb-e47c-4d57-9666-ab658463a10e.02610634-2cbf-4400-a588-5e2438b95c4e.8c1ac7e4-f399-458a-a570-4b3cfb7f4eb8
https://store-images.s-microsoft.com/image/apps.46473.86068fcb-e47c-4d57-9666-ab658463a10e.02610634-2cbf-4400-a588-5e2438b95c4e.1b3b30f0-ac2b-42da-ab36-1c14180099d7